package jwdt.xadmin.custom.bean;

import jwdt.common.util.CacheUtil;

import com.ezerg.db.Jdb;
import com.ezerg.db.annotation.Column;
import com.ezerg.db.annotation.Table;

@Table(name="t_contacts", keys={"id"}, comment="")
public class TContacts implements java.io.Serializable {

	private static final long serialVersionUID = 1L;

	@Column(value="id", comment="")
	private Integer id;
	
	@Column(value="name", comment="")
	private String name;
	
	@Column(value="email", comment="")
	private String email;
	
	@Column(value="tel", comment="")
	private String tel;
	
	@Column(value="phone", comment="")
	private String phone;
	
	@Column(value="duty", comment="")
	private String duty;
	
	@Column(value="dt", comment="")
	private String dt;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public String getTel() {
		return tel;
	}

	public void setTel(String tel) {
		this.tel = tel;
	}

	public String getPhone() {
		return phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}

	public String getDuty() {
		return duty;
	}

	public void setDuty(String duty) {
		this.duty = duty;
	}

	public String getDt() {
		return dt;
	}

	public void setDt(String dt) {
		this.dt = dt;
	}
	public static int getIdByDt(String dt) {
		return Jdb.get().queryForInt("select id from t_contacts where dt=?", new Object[]{dt}, CacheUtil.C0);
	}
}
